2016-08-16 - 27847 - Spec - Japan Material file extract #JapanMMPP #APAC #ABAPEXTRACT
SPECIFICATIONS
27847 - Spec - Japan Material Extract Program
Purpose
Japan Material Extract Program.
Admin Info
Purpose
|
Japan Material Extract Program
|
Requested By
|
Babu Lankipalli
|
Spec Created By
|
Laxman/ Adithya
|
Spec Created Date
|
08/16/2016
|
Spec QA by
|
Laxman
|
Objects
|
ZMM_JP_MAST_DC
|
Document Status
|
Completed
|
Estimates
Sl.No
|
Activity
|
Estimation in Hours
|
1
|
Research
|
|
2
|
Documentation
|
04
|
3
|
Development/ Config
|
24
|
4
|
Unit test in DEV
|
04
|
5
|
Unit test in QUA
|
04
|
6
|
Other activity
|
|
|
TOTAL
|
36
|
References
Prior Tickets
[Provide links of prior associated Spec / Break Fix BOSS document(s)]
Documents
[Attach any document(s) received for the requirement(s)]
Spec Changes
[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]
Sl.
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1
|
Do not consider the creation of Purchase Orders
|
Babu Vanamali
|
11/02/2016
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
[Explain the purpose of the project and the reason why this requirement has come]
Create a Program which shall generate a Material File Extract, which shall be similar to the NITSU file extract.
Add below given fields in the extract.
UOM
MSRP
Deletion Indicator
Master grid
Changes On Date 1
1/02/2016
Do not consider the creation and change of Purchase Orders.
File has to be created when the Material is Created, Changed for plant 0610 and if there is any change in the MSRP value for materials created for plant 0610.
Change the selection criteria:
- Remove the Purchasing Document field from Input
- Remove Date field from Input.
Following are the changes which are considered as trigger for the Japan Material Extract
Material Description.
Material EAN/UPC number.
Material Colour
Material Freight Group
Include in Menlo Check Box
MSRP value for the Material is changed/updated.
MSRP value for the Material is Deleted.
In Scope:
[List the
activities to be included in scope]
Material Creation, Material Changes, MSRP value update/deletion for Material.
Out of Scope:
[Out of scope activities]
Purchase Order Create/Change/Delete
Solution Summary
[Discuss this section with Requester and get approval prior to beginning work]
Since NITSU want upto date information of materials advised to modify the NITSU file extract. As advised we need to add below given fields to extract. They also want modified materials and MSRP changed materials to synchronize their data base with SAP.
UOM
MSRP
Deletion Indicator
Master grid
Dated 11/01/2016.
Changes to the input of the extraction Program which shall remove the Purchase Order Numbers and the Dates, so that the file would be generated by input of materials and the number of change days.
Test Plan
[List test scenarios/cases to be executed here]
Test ID
|
Test Scenario
|
Expected Results
|
MM001
|
Create a Material,
Change the Material:
Material Description.
Material EAN/UPC number.
Material Colour
Material Freight Group
Include in Menlo Check Box
Change MSRP Value of Material
MSRP value for the Material is changed/updated.
MSRP value for the Material is Deleted.
|
The material extract file shall be generated for all the changes listed
and file shall contain all new fields
|
MM002
|
Input the materials of plant 0610 and extract the file
|
File should contain above new fields with correct values
|
MM003
|
Change the material of plant 0610 and extract the file
|
File should contain above new fields with correct values
|
MM004
|
Change the MSRP of 0610 plant material and extract the file
|
File should contain above new fields with correct values
|
MM005
|
Run the Program in background, with changes and creation of
the materials
|
A file shall be generated for the changes and creation of the materials
and placed in the AL11 path.
|
Solution Details
[Provide complete technical details for configuration or programming here]
Created a program "ZMM_JP_MAST_DC" for the Japan Material Extract
by adding the new fields UOM, MSRP, Deletion indicator and Master grid.
Input of the program is now Materials and Number of days
Issues
[List Issues / Bugs identified in configuration or development]